package cn.hs.mapper;
import org.apache.ibatis.annotations.Param;
import java.util.List;

import cn.hs.entity.Appointment;

/**
* @author 86175
* @description 针对表【appointment】的数据库操作Mapper
* @createDate 2024-10-24 11:03:40
* @Entity cn.hs.entity.Appointment
*/
public interface AppointmentMapper {
    //根据id查询
    Appointment selectById(@Param("id") Integer id);
    //添加
    int insertAll(Appointment appointment);
    //删除
    int deleteById(@Param("id") Integer id);
    //查询全部
    List<Appointment> selectAll();
    //修改状态
    int updateStatus(@Param("status") Integer status,@Param("id") Integer id);

    int updateReplyById(@Param("reply") String reply, @Param("id") Integer id);

    List<Appointment> selectByConsultId(@Param("consultId") Integer consultId);

    List<Appointment> selectByUserId(@Param("userId") Integer userId);
}
